How to: AutoFormat a list.
Solution:
Select 'AutoFormat...' from the 'Format' menu and select the desired format from the 'Table Format' list box.
1) Select the entire list to format.
2) Select 'AutoFormat...' from the 'Format' menu. (The AutoFormat dialog box appears.)
3) Select the desired format from the 'Table Format' list box.
Selecting the desired format
4) Click 'OK'. (Excel automatically applies the format to the list.)
